How to Create Questions from a CSV File
How to Create Questions from a CSV File
STEP 1
On the editing screen of a Test Card, press ... and then select Import File.
https://gyazo.com/eb5b885f7c207437da93c54c7ac55ce3
STEP 2
Download the CSV file template for creating questions by selecting Download the CSV template.
https://gyazo.com/8f260af65cee4b49185b23f5fb7522b5
STEP 3
Create questions by editing the downloaded template with Excel or other software.
https://gyazo.com/45a4d8708ef0870ba8ff3f4fc46aa088
Note:
The same template can also used to edit Questionnaire Cards. Please do not delete the Score (Column C) and Correct Answer Choices (Column D) columns.
CSV Import Specification
If there is only one correct answer choice, the question is a Single Answer type; if there are multiple answers, the question will be a Multiple Answer type automatically.
If the answer choice is blank, the question will be an Free Answer type.
If a question has already been created, it will be added to the existing questions.
You can import up to 5 CSV files at a time. (Files can be added later on.)
If there is a line with an incorrect description, the question may not be created as intended. (No errors will be displayed either.)
STEP 4
Import the CSV file you've created, and if you are satisfied with the preview, select Create in this file to create the tests questions.
https://gyazo.com/6362a8ab72e4e438b0f1e5ac695e144ehttps://gyazo.com/0384a8d4478b8f3d8fb4c4cb1a60c677
Actions that are unavailable when importing CSV files
Images, audio, and video cannot be added through CSV files. Please add them directly through the app.
Test information placed on the toolbar, such as changing settings for automatic scoring, aggregate results, and setting the shared range of respondent names, cannot be set or updated.
Questions cannot be set to "Questions" only.
"Allow respondents to add choices" cannot be set through a CSV file.
Content of questions that have already been created cannot be edited.